Graphical Querying of Multidimensional Databases
نویسندگان
چکیده
This paper provides an answer-oriented multidimensional analysis environment. The approach is based on a conceptual point of view. We define a conceptual model that represents data through a constellation of facts and dimensions and we present a query algebra handling multidimensional data as well as multidimensional tables. Based on these two propositions, in order to ease the specification of multidimensional analysis queries, we define a formal graphical language implemented within a prototype: GraphicOLAPSQL.
منابع مشابه
Querying Multidimensional Data
A powerful, easy-to-use querying environment is without doubt one of the most important components in a multidimensional database. Its effectiveness is influenced by many aspects, both logical (data model, integration, policy of view materialization, etc.) and physical (multidimensional or relational storage, indexes, etc.). Multidimensional querying is often based on the core concepts of multi...
متن کاملA Logical Framework for Querying
We address the issue of designing e ective query languages for OLAP databases. The basis of our investigation is MD, a logical data model for multidimensional databases that, unlike other multidimensional models, is independent of any speci c implementation. As such, MD provides a clear separation between practical and conceptual aspects of multidimensional analysis. In this framework, we prese...
متن کاملRepresenting and querying histories of semistructured databases using multidimensional OEM
Multidimensional semistructured data (MSSD) are semistructured data that present different facets under different contexts. Context represents alternative worlds, and is expressed by assigning values to a set of user-defined variables called dimensions. The notion of context has been incorporated in the Object Exchange Model (OEM), and the extended model is called Multidimensional OEM (MOEM), a...
متن کاملPESTO : An Integrated Query/Browser for Object Databases
This paper describes the design and implementation of PEST0 (Portable Explorer of Snuctured Objects), a user interface that supports browsing and querying of object databases. PEST0 allows users to navigate the relationships that exist among objects. In addition, users can formulate complex object queries through an integrated query paradigm (“query-in-place”) that presents querying as a natura...
متن کاملConstraint-Based Multi-Dimensional Databases
This chapter deals with constraint-based multidimensional modelling. The model we define integrates a constellation of facts and dimensions. Along each dimension, various hierarchies are possibly defined and the model supports multiple instantiations of dimensions. The main contribution is the definition of intra-dimension constraints between hierarchies of a same dimension as well as inter-dim...
متن کامل